<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fp141670">gp_resqueue_status</title>
  <body>
    <p>The <codeph>gp_toolkit.gp_resqueue_status</codeph> view allows administrators to see status
      and activity for a resource queue. It shows how many queries are waiting
      to run and how many queries are currently active in the system from a particular resource
      queue.</p>
      <note>The <codeph>gp_resqueue_status</codeph> view is valid only when resource queue-based resource management is active.</note>
    <table id="fp141982">
      <title>gp_toolkit.gp_resqueue_status</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="114pt"/>
        <colspec colnum="2" colname="col2" colwidth="66pt"/>
        <colspec colnum="3" colname="col3" colwidth="133.5pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row>
            <entry colname="col1">column</entry>
            <entry colname="col2">type</entry>
            <entry colname="col3">references</entry>
            <entry colname="col4">description</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">
              <codeph>queueid</codeph>
            </entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ queueid</entry>
            <entry colname="col4">The ID of the resource queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqname</codeph>
            </entry>
            <entry colname="col2">name</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqname</entry>
            <entry colname="col4">The name of the resource queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqcountlimit</codeph>
            </entry>
            <entry colname="col2">real</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqcountlimit</entry>
            <entry colname="col4">The active query threshold of the resource queue. A value of -1
              means no limit.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqcountvalue</codeph>
            </entry>
            <entry colname="col2">real</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqcountvalue</entry>
            <entry colname="col4">The number of active query slots currently being used in the
              resource queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqcostlimit</codeph>
            </entry>
            <entry colname="col2">real</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqcostlimit</entry>
            <entry colname="col4">The query cost threshold of the resource queue. A value of -1
              means no limit.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqcostvalue</codeph>
            </entry>
            <entry colname="col2">real</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqcostvalue</entry>
            <entry colname="col4">The total cost of all statements currently in the resource
              queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqmemorylimit</codeph>
            </entry>
            <entry colname="col2">real</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqmemorylimit</entry>
            <entry colname="col4">The memory limit for the resource queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqmemoryvalue</codeph>
            </entry>
            <entry colname="col2">real</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqmemoryvalue</entry>
            <entry colname="col4">The total memory used by all statements currently in the resource
              queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqwaiters</codeph>
            </entry>
            <entry colname="col2">integer</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqwaiter</entry>
            <entry colname="col4">The number of statements currently waiting in the resource
              queue.</entry>
          </row>
          <row>
            <entry colname="col1">
              <codeph>rsqholders</codeph>
            </entry>
            <entry colname="col2">integer</entry>
            <entry colname="col3">gp_toolkit.gp_resqueue_ rsqholders</entry>
            <entry colname="col4">The number of statements currently running on the system from this
              resource queue.</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
